package com.project.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.project.demo.entity.Water;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;

public interface Watermapper extends BaseMapper<Water> {
    @Delete("delete from statistics.water where username=#{name}")
    Integer deleteVo(Integer name);
    @Insert("insert into statistics.water values(#{liuyu},#{username},#{kuname},#{rongliang},#{xushui},#{dayaverge},#{dayhigh},#{maxfall},#{hole})")
    Integer insertVo(String liuyu, Integer username,String kuname,Integer rongliang,Integer xushui,Integer dayaverge,Integer dayhigh,Integer maxfall,Integer hole);
}
